<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<meta http-equiv="Content-Style-Type" content="text/css" />
				<title>1.9&#xa0;&#xa0;&#xa0; 进程管理</title>
		<link href="xcloud-sqldeveloper-helper.css" type="text/css" rel="stylesheet" />
	</head>
	<body><h2 style="margin-left:28.35pt; text-indent:-28.35pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9</span><span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0; </span><a name="_Toc443396561">进程管理</a></h2>
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9.1</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396562">进程管理</a></h3>
			<p style="margin-top:0pt; margin-bottom:0pt; text-align:left; widows:2; orphans:2">①、打开SQL Developer管理平台，使用systemadmin用户登录，右击选中数据库，弹出分配进程和回收进程界面</p>
			<p style="margin-top:0pt; margin-bottom:0pt; text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.001.png" width="547" height="297" alt="" />
			</p>
			<p style="margin-top:0pt; margin-bottom:0pt; text-align:left; widows:2; orphans:2">&#xa0;</p>
			<p style="margin-top:0pt; margin-bottom:0pt; text-align:left; widows:2; orphans:2">②、点击分配进程或回收进程，弹出分配进程或回收进程对话框，用户通过勾选按钮来分配或收回进程，点击查看sql按钮查看对应的sql语句，如图</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.002.png" width="554" height="486" alt="" />
			</p>
				
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.002_1.png" width="554" height="486" alt="" />
			</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.003.png" width="554" height="478" alt="" />
			</p>
			
			
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9.2</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396563">进程视图</a></h3>
			<p> ①、点击进程视图，查看进程分配情况，如图：</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.004.png" width="554" height="261" alt="" />
			</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.005.png" width="554" height="137" alt="" />
			</p>
	
			
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9.3</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396564">新建进程组</a></h3>
			<p> ①、打开SQL Developer管理平台，通过左侧导航树以system用户登陆，右击进程组结点，如下图所示：</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.006.png" width="527" height="174" alt="" />
			</p>
			
			<p> ②、点击新建进程组，弹出如下对话框，输入进程组名，点击确定按钮，点击查看sql按钮可查看当前操作生成的sql语句。如下图所示：</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.007.png" width="346" height="211" alt="" />
			</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.008.png" width="550" height="479" alt="" />
			</p>
			
			
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9.4</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396565">删除进程组</a></h3>
			<p> ①、选择进程组结点下的子节点，右击选择删除按钮，弹出如下确认对话框，点击确定按钮，删除进程组：</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.009.png" width="492" height="143" alt="" />
			</p>
		
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9.5</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396566">单一进程组编辑</a></h3>
			<p> ①、选择进程组结点下的子节点，右键选择进程分配钮或进程回收按钮，弹出如下对话框,分配或收回进程后，点击完成，完成操作，点击查看sql，查看sql语句：</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.010.png" width="552" height="493" alt="" />
			</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.010_1.png" width="552" height="493" alt="" />
			</p>
<!-- 			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9.6</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396567">进程组编辑</a></h3>
			<p> ①、选择进程组结点，右键选择编辑按钮，弹出如下对话框,分配进程后，点击完成，完成操作，点击查看sql，查看sql语句：</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.011.png" width="549" height="494" alt="" />
			</p> -->
			
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9.6</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396568">进程组管理(单用户)</a></h3>
			<p> ①、选择用户结点下的子节点，右键选择进程组管理，弹出如下对话框,分配进程组后，点击完成，完成操作，点击查看sql，查看sql语句：</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.012.png" width="554" height="322" alt="" />
			</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.013.png" width="554" height="494" alt="" />
			</p>
			
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.9.7</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396569">进程组管理(多用户)</a></h3>
			<p> ①、选择用户结点，右键选择进程组管理，弹出如下对话框,分配进程组后，点击完成，完成操作，点击查看sql，查看sql语句：</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.014.png" width="549" height="314" alt="" />
			</p>
			<p style="text-align:center; widows:2; orphans:2">
				<img src="xcloud-sqldeveloper-helper-process/xcloud-sqldeveloper-helper-process.015.png" width="549" height="378" alt="" />
			</p>
		
			<p style="margin-top:0pt; margin-bottom:0pt; text-indent:0pt; widows:2; orphans:2">&#xa0;</p>
			<p style="margin-top:0pt; margin-bottom:0pt; text-indent:0pt; widows:2; orphans:2">&#xa0;</p>
			</body>
</html>